﻿CREATE TABLE [dbo].[PerfilPersona] (
    [IdPerfilPersona] INT          IDENTITY (1, 1) NOT NULL,
    [IdPerfil]        INT          NOT NULL,
    [IdPersona]       INT          NOT NULL,
    [Estado]          VARCHAR (20) NOT NULL,
    CONSTRAINT [PK_PerfilPersona] PRIMARY KEY CLUSTERED ([IdPerfilPersona] ASC),
    CONSTRAINT [FK_Perfil] FOREIGN KEY ([IdPerfil]) REFERENCES [dbo].[Perfil] ([IdPerfil]),
    CONSTRAINT [FK_Persona] FOREIGN KEY ([IdPersona]) REFERENCES [dbo].[Persona] ([IdPersona])
);

